/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-05-24 17:55:55
*/


-- ----------------------------
-- Table structure for tb3532
-- ----------------------------
DROP TABLE [dbo].[tb3532]
GO
CREATE TABLE [dbo].[tb3532] (
[TransactionID] varchar(20) NOT NULL ,
[QuotationID] varchar(20) NOT NULL ,
[InventoryID] varchar(20) NULL ,
[QuoQuantity] decimal(28,8) NULL ,
[UnitPrice] money NULL ,
[OriginalAmount] money NULL ,
[ConvertedAmount] money NULL ,
[Notes] nvarchar(500) NULL ,
[Notes01] nvarchar(250) NULL ,
[Notes02] nvarchar(250) NULL ,
[VATPercent] money NULL ,
[VATConvertedAmount] money NULL ,
[VATOriginalAmount] money NULL ,
[UnitID] varchar(20) NULL ,
[Orders] int NULL ,
[DiscountPercent] money NULL ,
[DiscountOriginalAmount] money NULL ,
[DiscountConvertedAmount] money NULL ,
[InventoryCommonName] nvarchar(250) NULL ,
[Ana03ID] varchar(20) NULL ,
[Ana02ID] varchar(20) NULL ,
[Ana01ID] varchar(20) NULL ,
[Ana04ID] varchar(20) NULL ,
[Ana05ID] varchar(20) NULL ,
[UnitPrice2] money NULL ,
[OriginalAmount2] money NULL ,
[ConvertedAmount2] money NULL ,
[ConvertedAmountDifference] money NULL ,
[WarrantyDuration] int NULL ,
[ShipDate] int NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb3532
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb3532
-- ----------------------------
ALTER TABLE [dbo].[tb3532] ADD PRIMARY KEY NONCLUSTERED ([TransactionID])
GO

-- ----------------------------
-- Checks structure for table tb3532
-- ----------------------------
ALTER TABLE [dbo].[tb3532] ADD CHECK (([QuotationID] IS NOT NULL AND [QuotationID]<>''))
GO
